package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_CompoundUniqueGroup({
        @_DDL_CompoundUnique(name = "UNI_bs_id_key", columns = {"bs_id", "key"})
})
@_DDL_Table(name = "c_bs_usr", simpleName = "", engine = MysqlDriver.InnoDB, comment = "")
public class _DDL_CBsUsr {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, nullable = false, autoIncrement = true, comment = "id")
    private Long id;

    @_DDL_Column(name = "bs_id", type = SqlType.INT_UNSIGNED, comment = "户id")
    private Long bsId;

    @_DDL_Column(name = "key", type = SqlType.VARCHAR, size = 32, nullable = false, comment = "身份证号md5")
    private String key;

    @_DDL_Column(name = "usr_id", type = SqlType.INT_UNSIGNED, comment = "用户id")
    private Long usrId;

    @_DDL_Column(name = "id_no", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "身份证号展示")
    private String idNo;

    @_DDL_Column(name = "state", type = SqlType.TINYINT_UNSIGNED, comment = "状态 0:正常 1：停用")
    private Integer state;

    @_DDL_Column(name = "phone", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "手机号码")
    private String phone;

    @_DDL_Column(name = "name", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "姓名")
    private String name;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

}
